<?php
define('InEmpireBakData',TRUE);
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 5.1
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `jzb_order`;");
E_C("CREATE TABLE `jzb_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_no` char(50) NOT NULL,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
  `consignee` char(20) NOT NULL DEFAULT '' COMMENT '收货人',
  `province_id` char(6) NOT NULL DEFAULT '' COMMENT '省',
  `city_id` char(6) NOT NULL DEFAULT '' COMMENT '市',
  `area_id` char(6) NOT NULL DEFAULT '' COMMENT '地区',
  `address` char(100) NOT NULL DEFAULT '' COMMENT '详细地址',
  `mobile` char(30) NOT NULL DEFAULT '' COMMENT '手机号码',
  `payment_log_id` int(11) NOT NULL DEFAULT '0' COMMENT '支付方式',
  `shipping_price` decimal(14,2) DEFAULT NULL COMMENT '运费金额',
  `price` decimal(14,2) DEFAULT NULL COMMENT '订单金额',
  `comment` char(255) NOT NULL DEFAULT '' COMMENT '评论',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_status` int(11) DEFAULT NULL COMMENT '订单状态',
  `shipping_status` int(11) DEFAULT NULL COMMENT '发货状态',
  `review_status` int(11) DEFAULT NULL,
  `shipping_time` int(11) DEFAULT NULL COMMENT '配送日期',
  `confirm_time` int(11) NOT NULL DEFAULT '0' COMMENT '确认时间',
  `complate_time` int(11) NOT NULL DEFAULT '0' COMMENT '完成时间',
  `pay_time` int(10) DEFAULT NULL COMMENT '支付时间',
  `pay_status` int(1) DEFAULT '0' COMMENT '支付状态',
  `apply_notice` varchar(512) DEFAULT NULL COMMENT '退款声明',
  `refund_desc` varchar(225) DEFAULT NULL COMMENT '理由',
  `is_score_product` tinyint(1) DEFAULT '0' COMMENT '0:不是积分商品，1：是平台积分商品',
  `score_num` int(11) DEFAULT '0' COMMENT '需要支付的积分数量',
  `pay_style` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8");
E_D("replace into `jzb_order` values('1',0x32303136313032323835363438,'2',0xe5bca0e59bbde5b885,0x313330303030,0x313330343030,0x313330343330,0xe59088e4b989e8b7afe4b88ee4b8ade585b4e8a197e4baa4e58f89e58fa3e58d97e8a18c3230e7b1b3,0x3138303334323036353131,'0',NULL,'5.00','','1477120415','0','0','1','0','0','0','1477120416','0',NULL,'0',NULL,NULL,'0','0','0');");
E_D("replace into `jzb_order` values('2',0x32303136313032333139393932,'5',0xe99988e69687e6b5a9,0x313330303030,0x313330343030,0x313330343330,0xe59088e4b880e8b7afe4b88ee4b8ade585b4e8a197e4baa4e58f89e58fa3e58d97e8a18c3230e7b1b3,0x3135313032363932333834,'0',NULL,'200.00','','1477183200','0','0','1','0','0','0','1477183200','0',NULL,'0',NULL,NULL,'0','0','0');");
E_D("replace into `jzb_order` values('3',0x32303136313032333039303930,'21',0xe78e8be69dbe,0x313330303030,0x313330343030,0x313330343330,0xe59f8ee5b882e88ab1e59bade58d97e997a8e8a5bfe8a18c3230e7b1b3e8b7afe58d97,0x3135313838383331373135,'0',NULL,'650.00','','1477205963','0','0','1','0','0','0','0','0','1477205963','1',NULL,NULL,'1','10','0');");
E_D("replace into `jzb_order` values('4',0x32303136313032333733373439,'21',0xe78e8be69dbe,0x313330303030,0x313330343030,0x313330343330,0xe59f8ee5b882e88ab1e59bade58d97e997a8e8a5bfe8a18c3230e7b1b3e8b7afe58d97,0x3135313838383331373135,'0',NULL,'50.00','','1477205972','0','0','1','0','0','0','0','0','1477205972','1',NULL,NULL,'1','10','0');");
E_D("replace into `jzb_order` values('5',0x32303136313032353235303138,'2',0xe5bca0e59bbde5b885,0x313330303030,0x313330343030,0x313330343330,0xe59088e4b989e8b7afe4b88ee4b8ade585b4e8a197e4baa4e58f89e58fa3e58d97e8a18c3230e7b1b3,0x3138303334323036353131,'0',NULL,'799.00','','1477363543','0','0','1','0','0','0','1477363543','0',NULL,'0',NULL,NULL,'0','0','0');");

require("../../inc/footer.php");
?>